Mastering PostgreSQL in Application Development by Dimitri Fontaine

Author:Dimitri Fontaine
Language: eng
Format: epub
Published: 0101-01-01T00:00:00+00:00

Which by the way gives:

year │ code │ name │ count ══════╪══════╪════════════════════╪═══════ 1992 │ ¤ │ Nigel Mansell │ 9 2011 │ VET │ Sebastian Vettel │ 9 2013 │ VET │ Sebastian Vettel │ 8 2004 │ MSC │ Michael Schumacher │ 8 2016 │ HAM │ Lewis Hamilton │ 7 2015 │ HAM │ Lewis Hamilton │ 7 1988 │ ¤ │ Ayrton Senna │ 7 1991 │ ¤ │ Ayrton Senna │ 7 2001 │ MSC │ Michael Schumacher │ 6 2014 │ HAM │ Lewis Hamilton │ 6 (10 rows)

Also impacting on the PostgreSQL parsing choice of a data type for the 1 literal is the = operator, which exists in three different variants when its left operand is a bigint value:

select oprname, oprcode::regproc, oprleft::regtype, oprright::regtype, oprresult::regtype from pg_operator where oprname = '=' and oprleft::regtype = 'bigint'::regtype;

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.